Excel 2019 - Applying Custom and Conditional Formats and Validating Data
      This course is part of the MOS exam 77-727 range that will teach you the essential skills to successfully pass the Microsoft Office Specialist (MOS) certification exam. In this course you will learn about Custom and Conditional Formats. You will also learn about Validating Data.      
      Custom and Conditional Formats      
      Upon successful completion you will be able to:

1. Apply Numeric Formats;
2. Apply Currency Formats;
3. Apply Accounting Formats;
4. Create Custom Formats;
5. Use Conditional Formatting;
6. Create Formatting Rules;
7. Display Icon Sets;
8. Clear Rules;
9. Use Data Bars.


      
      Validating Data      
      Upon successful completion you will be able to:

1. Use the Data Validation feature;
2. Set Validation Criteria;
3. Create Input Messages;
4. Create Error Alert Messages;
5. Create Named Ranges;
6. Create Data Entry Lists;
7. Enter Data Using Lists.
      
This course can be purchased either individaully or as part of a package.
Single Training Course - Excel 2019 - Applying Custom and Conditional Formats and Validating Data :
Program Training Courses - Microsoft Excel 2019 :
Office Suite Training Courses - Microsoft Office 2019 / Office 365 :
© 2020 Online Training Masters